﻿//-----------------------------------------------------------------------
// <copyright company="www.3WayWebdesign.de">
// Permission is hereby granted, free of charge, to any person obtaining
// a copy of this software and associated documentation files (the
// "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish,
// distribute, sublicense, and/or sell copies of the Software, and to
// permit persons to whom the Software is furnished to do so, subject to
// the following conditions:
//
// The above copyright notice and this permission notice shall be
// included in all copies or substantial portions of the Software.
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
// </copyright>
//
// <author>Michael Morbach</author>
// <email>Michael@3waywebdesign.de</email>
// <web>http://www.3waywebdesign.de</web>
//-----------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using Tww.Pixxler.PixxlerService.DataModel;
using Tww.Pixxler.SharedObjects.DTO;

namespace Tww.Pixxler.PixxlerService.DataLayer
{
    public class AlbumRepository
    {
        public PixxlerAlbumDTO GetAlbum( Guid albumID )
        {
            using ( var pixxlerContext = new DataModel.PixxlerDataContext() )
            {
                return pixxlerContext.pxl_Album.Where( a => a.IDAlbum == albumID )
                                               .Select( f => new PixxlerAlbumDTO()
                                                               {
                                                                   AlbumID = f.IDAlbum,
                                                                   AlbumTitel = f.Titel,
                                                                   BesitzerID = f.BesitzerBenutzerID,
                                                                   ErstelltAm = f.ErstelltAm
                                                               } ).FirstOrDefault();
            }
        }

        public List<PixxlerAlbumDTO> GetBenutzerAlben( Guid userID )
        {
            using ( var pixxlerContext = new DataModel.PixxlerDataContext() )
            {
                return pixxlerContext.pxl_Album.Where( a => a.BesitzerBenutzerID == userID )
                                               .Select( f => new PixxlerAlbumDTO()
                                               {
                                                   AlbumID = f.IDAlbum,
                                                   AlbumTitel = f.Titel,
                                                   BesitzerID = f.BesitzerBenutzerID,
                                                   ErstelltAm = f.ErstelltAm
                                               } ).ToList();
            }
        }

        public PixxlerAlbumDTO CreateNewAlbum( Guid ownerID )
        {
            using ( var pixxlerDataContext = new DataModel.PixxlerDataContext() )
            {
                var newFolder = new pxl_Album()
                {
                    BesitzerBenutzerID = ownerID,
                    ErstelltAm = DateTime.Now,
                    IDAlbum = Domain.PixxlerService.IDGenerator.CreateGuid(),
                    Titel = "Ohne Titel"
                };

                var relation = new pxl_BenutzerAlben()
                {
                    AlbumID = newFolder.IDAlbum,
                    BenutzerID = ownerID,
                    CanAdd = true,
                    CanDelete = true,
                    CanView = true,
                };

                pixxlerDataContext.pxl_Album.Add( newFolder );
                pixxlerDataContext.pxl_BenutzerAlben.Add( relation );

                pixxlerDataContext.SaveChanges();

                return this.GetAlbum( newFolder.IDAlbum );
            }
        }
    }
}